The standard Text Import/Export Mappings utility is a powerful conversion utility to convert text files such as CSV and TXT files to EBMS files. EBMS does NOT import or export a CSV UTF-8 file. This utility can process mapped EBMS files to update EBMS inventory information on a regular basis. This conversion process can be automated to update information from a user defined location such as a FTP site on a user defined schedule. This utility is used frequently to update vendor catalog files or product application files but can also be used to import information into standard EBMS files. Note that this standard utility is included in all EBMS versions 7.8 and higher.
Information is an important component in many point-of-sale or inventory management systems. This utility can automate the update of EBMS data from an outside source such as a text file from a vendor or manufacturer. The information source can post data to a standard FTP or other cloud based site for easy retrieval. EBMS can be scheduled to access this information from the cloud and update the EBMS information on a regular basis. Use the Import/Export Mappings dialog to launch this utility.
Complete the following steps to configure a Text Import Export Mapping:
Click Export to reverse the import process and create a text file from an EBMS file. Review Export EBMS Data to a Text File for more details on this function.
Create multiple Import/Export Mappings records for different file imports.
Review the following links for examples of processes that use this tool:
Vendor catalog: Review [Inventory] Vendor Catalog > Overview for details on the steps to import product information from electronic vendor supplied catalog files.